Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	157338
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	19.2 MiB
Average record size in memory	128.0 B

Variable types

Categorical	1
Numeric	12

Alerts

`DATETIME` has a high cardinality: 157338 distinct values	High cardinality
`System Buy Price(GBP/MWh)` is highly overall correlated with `Market Index Price (£/MWh)`	High correlation
`Market Index Price (£/MWh)` is highly overall correlated with `System Buy Price(GBP/MWh)`	High correlation
`National demand (MW)` is highly overall correlated with `Total system demand (MW)` and 1 other fields	High correlation
`Embbeded wind generation (MW)` is highly overall correlated with `Wind generation (MW)`	High correlation
`Embbeded solar generation (MW)` is highly overall correlated with `Solar generation (MW)`	High correlation
`Total system demand (MW)` is highly overall correlated with `National demand (MW)` and 1 other fields	High correlation
`Wind generation (MW)` is highly overall correlated with `Embbeded wind generation (MW)`	High correlation
`Solar generation (MW)` is highly overall correlated with `Embbeded solar generation (MW)`	High correlation
`Hydro generation (MW)` is highly overall correlated with `National demand (MW)` and 1 other fields	High correlation
`DATETIME` is uniformly distributed	Uniform
`DATETIME` has unique values	Unique
`Embbeded solar generation (MW)` has 73336 (46.6%) zeros	Zeros
`Solar generation (MW)` has 77767 (49.4%) zeros	Zeros
`Biomass generation (MW)` has 67010 (42.6%) zeros	Zeros

Reproduction

Analysis started	2023-08-08 23:32:14.992749
Analysis finished	2023-08-08 23:33:27.160143
Duration	1 minute and 12.17 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

DATETIME
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	157338
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	11.4 MiB

2014-01-01 00:00:00	1
2020-01-02 07:00:00	1
2020-01-02 03:30:00	1
2020-01-02 04:00:00	1
2020-01-02 04:30:00	1
Other values (157333)	157333

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2989422
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	157338 ?
Unique (%)	100.0%

Sample

1st row	2014-01-01 00:00:00
2nd row	2014-01-01 00:30:00
3rd row	2014-01-01 01:00:00
4th row	2014-01-01 01:30:00
5th row	2014-01-01 02:00:00

Common Values

Value	Count	Frequency (%)
2014-01-01 00:00:00	1	< 0.1%
2020-01-02 07:00:00	1	< 0.1%
2020-01-02 03:30:00	1	< 0.1%
2020-01-02 04:00:00	1	< 0.1%
2020-01-02 04:30:00	1	< 0.1%
2020-01-02 05:00:00	1	< 0.1%
2020-01-02 05:30:00	1	< 0.1%
2020-01-02 06:00:00	1	< 0.1%
2020-01-02 06:30:00	1	< 0.1%
2020-01-02 07:30:00	1	< 0.1%
Other values (157328)	157328	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
16:00:00	3278	1.0%
22:30:00	3278	1.0%
18:00:00	3278	1.0%
18:30:00	3278	1.0%
19:00:00	3278	1.0%
19:30:00	3278	1.0%
20:00:00	3278	1.0%
20:30:00	3278	1.0%
21:00:00	3278	1.0%
21:30:00	3278	1.0%
Other values (3316)	281896	89.6%

Most occurring characters

Value	Count	Frequency (%)
0	1003481	33.6%
2	365450	12.2%
1	343658	11.5%
-	314676	10.5%
:	314676	10.5%
	157338	5.3%
3	134949	4.5%
7	59478	2.0%
8	59478	2.0%
5	59432	2.0%
Other values (3)	176806	5.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2202732	73.7%
Dash Punctuation	314676	10.5%
Other Punctuation	314676	10.5%
Space Separator	157338	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1003481	45.6%
2	365450	16.6%
1	343658	15.6%
3	134949	6.1%
7	59478	2.7%
8	59478	2.7%
5	59432	2.7%
4	59096	2.7%
6	59048	2.7%
9	58662	2.7%

Dash Punctuation

Value	Count	Frequency (%)
-	314676	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	314676	100.0%

Space Separator

Value	Count	Frequency (%)
	157338	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2989422	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1003481	33.6%
2	365450	12.2%
1	343658	11.5%
-	314676	10.5%
:	314676	10.5%
	157338	5.3%
3	134949	4.5%
7	59478	2.0%
8	59478	2.0%
5	59432	2.0%
Other values (3)	176806	5.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2989422	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1003481	33.6%
2	365450	12.2%
1	343658	11.5%
-	314676	10.5%
:	314676	10.5%
	157338	5.3%
3	134949	4.5%
7	59478	2.0%
8	59478	2.0%
5	59432	2.0%
Other values (3)	176806	5.9%

System Buy Price(GBP/MWh)
Real number (ℝ)

Distinct	37768
Distinct (%)	24.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.108926

Minimum	0
Maximum	4037.8
Zeros	718
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	14.99
Q1	32.939999
median	46.116501
Q3	70.119001
95-th percentile	226.05
Maximum	4037.8
Range	4037.8
Interquartile range (IQR)	37.179003

Descriptive statistics

Standard deviation	89.360764
Coefficient of variation (CV)	1.2745989
Kurtosis	440.03067
Mean	70.108926
Median Absolute Deviation (MAD)	16.466501
Skewness	13.146584
Sum	11030798
Variance	7985.3462
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	892	0.6%
65	720	0.5%
0	718	0.5%
40	705	0.4%
30	690	0.4%
55	685	0.4%
60	670	0.4%
45	639	0.4%
25	605	0.4%
20	501	0.3%
Other values (37758)	150513	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	718	0.5%
0.002000000095	1	< 0.1%
0.004999999888	2	< 0.1%
0.009999999776	7	< 0.1%
0.01099999994	1	< 0.1%
0.01999999955	1	< 0.1%
0.03999999911	5	< 0.1%
0.05000000075	22	< 0.1%
0.09000000358	4	< 0.1%
0.1000000015	25	< 0.1%

Value	Count	Frequency (%)
4037.800049	2	< 0.1%
4035.97998	1	< 0.1%
4005.97998	2	< 0.1%
4000	2	< 0.1%
3929.310059	2	< 0.1%
3854.310059	1	< 0.1%
3763.75	1	< 0.1%
3750	1	< 0.1%
3738.800049	3	< 0.1%
3435.97998	1	< 0.1%

Market Index Price (£/MWh)
Real number (ℝ)

Distinct	24359
Distinct (%)	15.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.942788

Minimum	0
Maximum	1983.66
Zeros	223
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	24.280001
Q1	35.5225
median	44.650002
Q3	62.5675
95-th percentile	211.29299
Maximum	1983.66
Range	1983.66
Interquartile range (IQR)	27.045

Descriptive statistics

Standard deviation	70.671211
Coefficient of variation (CV)	1.0401577
Kurtosis	43.116058
Mean	67.942788
Median Absolute Deviation (MAD)	11.32
Skewness	4.4347601
Sum	10689982
Variance	4994.4199
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	223	0.1%
36.75	68	< 0.1%
35.52000046	68	< 0.1%
35.02999878	66	< 0.1%
35.81999969	64	< 0.1%
37.49000168	63	< 0.1%
40	63	< 0.1%
37.15999985	63	< 0.1%
35.68999863	62	< 0.1%
37.54000092	62	< 0.1%
Other values (24349)	156536	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	223	0.1%
0.009999999776	4	< 0.1%
0.01999999955	3	< 0.1%
0.02999999933	3	< 0.1%
0.05000000075	1	< 0.1%
0.0700000003	3	< 0.1%
0.07999999821	3	< 0.1%
0.1000000015	2	< 0.1%
0.1099999994	2	< 0.1%
0.1299999952	1	< 0.1%

Value	Count	Frequency (%)
1983.660034	1	< 0.1%
1893.02002	1	< 0.1%
1837.890015	1	< 0.1%
1817.359985	1	< 0.1%
1815.369995	1	< 0.1%
1795.97998	1	< 0.1%
1699.73999	1	< 0.1%
1676.839966	1	< 0.1%
1561.589966	1	< 0.1%
1557.209961	1	< 0.1%

Market Index Volume (MWh)
Real number (ℝ)

Distinct	37760
Distinct (%)	24.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	872.35283

Minimum	0
Maximum	3743.3501
Zeros	221
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	258.3925
Q1	504.96251
median	784.09998
Q3	1157.2
95-th percentile	1779.3575
Maximum	3743.3501
Range	3743.3501
Interquartile range (IQR)	652.23744

Descriptive statistics

Standard deviation	479.34305
Coefficient of variation (CV)	0.549483
Kurtosis	0.78887981
Mean	872.35283
Median Absolute Deviation (MAD)	313.34998
Skewness	0.89833122
Sum	1.3725425 × 10⁸
Variance	229769.75
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	221	0.1%
312.5	28	< 0.1%
473	28	< 0.1%
424.5	25	< 0.1%
467	25	< 0.1%
371.5	25	< 0.1%
422.5	24	< 0.1%
328	24	< 0.1%
418.5	24	< 0.1%
418	22	< 0.1%
Other values (37750)	156892	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	221	0.1%
25	14	< 0.1%
25.79999924	1	< 0.1%
26	2	< 0.1%
26.75	1	< 0.1%
26.95000076	1	< 0.1%
27	1	< 0.1%
27.45000076	1	< 0.1%
27.5	2	< 0.1%
28.20000076	1	< 0.1%

Value	Count	Frequency (%)
3743.350098	1	< 0.1%
3662.649902	1	< 0.1%
3660.899902	1	< 0.1%
3658.649902	1	< 0.1%
3594.399902	1	< 0.1%
3537.099854	1	< 0.1%
3474	1	< 0.1%
3452.300049	1	< 0.1%
3431.649902	1	< 0.1%
3427.100098	1	< 0.1%

Settlement Period
Real number (ℝ)

Distinct	48
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.499123

Minimum	1
Maximum	48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	24
Q3	36
95-th percentile	46
Maximum	48
Range	47
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	13.852979
Coefficient of variation (CV)	0.56544795
Kurtosis	-1.201023
Mean	24.499123
Median Absolute Deviation (MAD)	12
Skewness	1.5164132 × 10^-5
Sum	3854643
Variance	191.90502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1	3278	2.1%
36	3278	2.1%
27	3278	2.1%
28	3278	2.1%
29	3278	2.1%
30	3278	2.1%
31	3278	2.1%
32	3278	2.1%
33	3278	2.1%
34	3278	2.1%
Other values (38)	124558	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3278	2.1%
2	3278	2.1%
3	3278	2.1%
4	3278	2.1%
5	3278	2.1%
6	3278	2.1%
7	3278	2.1%
8	3278	2.1%
9	3278	2.1%
10	3278	2.1%

Value	Count	Frequency (%)
48	3275	2.1%
47	3275	2.1%
46	3278	2.1%
45	3278	2.1%
44	3278	2.1%
43	3278	2.1%
42	3278	2.1%
41	3278	2.1%
40	3278	2.1%
39	3278	2.1%

National demand (MW)
Real number (ℝ)

Distinct	30155
Distinct (%)	19.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29932.852

Minimum	13367
Maximum	79138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	13367
5-th percentile	19605
Q1	24318
median	29218
Q3	34847.75
95-th percentile	42730
Maximum	79138
Range	65771
Interquartile range (IQR)	10529.75

Descriptive statistics

Standard deviation	7182.9297
Coefficient of variation (CV)	0.2399681
Kurtosis	0.26846182
Mean	29932.852
Median Absolute Deviation (MAD)	5212
Skewness	0.52661043
Sum	4.709575 × 10⁹
Variance	51594480
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27344	21	< 0.1%
29646	21	< 0.1%
25873	20	< 0.1%
27854	20	< 0.1%
29149	19	< 0.1%
30329	19	< 0.1%
25190	19	< 0.1%
26210	19	< 0.1%
29604	19	< 0.1%
25847	19	< 0.1%
Other values (30145)	157142	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13367	1	< 0.1%
13394	1	< 0.1%
13597	1	< 0.1%
13737	1	< 0.1%
13745	1	< 0.1%
13923	1	< 0.1%
14061	1	< 0.1%
14075	1	< 0.1%
14261	1	< 0.1%
14389	1	< 0.1%

Value	Count	Frequency (%)
79138	1	< 0.1%
78769	1	< 0.1%
78669	1	< 0.1%
78342	1	< 0.1%
78328	1	< 0.1%
77565	1	< 0.1%
77180	1	< 0.1%
77177	1	< 0.1%
77110	1	< 0.1%
77085	1	< 0.1%

Embbeded wind generation (MW)
Real number (ℝ)

Distinct	4978
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1501.4337

Minimum	83
Maximum	5634
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	83
5-th percentile	339
Q1	731
median	1282
Q3	2070
95-th percentile	3398
Maximum	5634
Range	5551
Interquartile range (IQR)	1339

Descriptive statistics

Standard deviation	972.27356
Coefficient of variation (CV)	0.64756344
Kurtosis	0.56930178
Mean	1501.4337
Median Absolute Deviation (MAD)	630
Skewness	0.97455847
Sum	2.3623257 × 10⁸
Variance	945315.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
502	132	0.1%
578	130	0.1%
580	125	0.1%
540	125	0.1%
552	124	0.1%
686	121	0.1%
940	119	0.1%
618	113	0.1%
494	112	0.1%
602	112	0.1%
Other values (4968)	156125	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
83	2	< 0.1%
86	2	< 0.1%
88	2	< 0.1%
90	6	< 0.1%
91	2	< 0.1%
92	2	< 0.1%
96	2	< 0.1%
97	6	< 0.1%
98	4	< 0.1%
100	2	< 0.1%

Value	Count	Frequency (%)
5634	1	< 0.1%
5616	1	< 0.1%
5598	2	< 0.1%
5588	1	< 0.1%
5578	1	< 0.1%
5564	1	< 0.1%
5521	1	< 0.1%
5463	1	< 0.1%
5452	1	< 0.1%
5441	1	< 0.1%

Embbeded solar generation (MW)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	5607
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1175.5372

Minimum	0
Maximum	13060
Zeros	73336
Zeros (%)	46.6%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	23
Q3	1810
95-th percentile	5390
Maximum	13060
Range	13060
Interquartile range (IQR)	1810

Descriptive statistics

Standard deviation	1869.7026
Coefficient of variation (CV)	1.5905091
Kurtosis	2.6786849
Mean	1175.5372
Median Absolute Deviation (MAD)	23
Skewness	1.7932217
Sum	1.8495667 × 10⁸
Variance	3495788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73336	46.6%
1	1536	1.0%
2	729	0.5%
3	465	0.3%
4	319	0.2%
5	242	0.2%
6	207	0.1%
7	197	0.1%
1050	176	0.1%
1120	175	0.1%
Other values (5597)	79956	50.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	73336	46.6%
1	1536	1.0%
2	729	0.5%
3	465	0.3%
4	319	0.2%
5	242	0.2%
6	207	0.1%
7	197	0.1%
8	171	0.1%
9	149	0.1%

Value	Count	Frequency (%)
13060	1	< 0.1%
12910	1	< 0.1%
12800	2	< 0.1%
12500	1	< 0.1%
12480	1	< 0.1%
12430	1	< 0.1%
12310	1	< 0.1%
12300	1	< 0.1%
12260	1	< 0.1%
11980	1	< 0.1%

Total system demand (MW)
Real number (ℝ)

Distinct	29414
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31373.069

Minimum	16629
Maximum	80820
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	16629
5-th percentile	21601
Q1	26018
median	30561
Q3	35899
95-th percentile	44027
Maximum	80820
Range	64191
Interquartile range (IQR)	9881

Descriptive statistics

Standard deviation	6932.311
Coefficient of variation (CV)	0.22096375
Kurtosis	0.55050778
Mean	31373.069
Median Absolute Deviation (MAD)	4866
Skewness	0.63173485
Sum	4.936176 × 10⁹
Variance	48056936
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32717	24	< 0.1%
29696	20	< 0.1%
31021	20	< 0.1%
27529	20	< 0.1%
27615	19	< 0.1%
26586	19	< 0.1%
29967	19	< 0.1%
30467	19	< 0.1%
31788	18	< 0.1%
28366	18	< 0.1%
Other values (29404)	157142	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16629	1	< 0.1%
16741	1	< 0.1%
16856	1	< 0.1%
16888	1	< 0.1%
16952	1	< 0.1%
16954	1	< 0.1%
17053	1	< 0.1%
17083	1	< 0.1%
17119	1	< 0.1%
17193	1	< 0.1%

Value	Count	Frequency (%)
80820	1	< 0.1%
80722	1	< 0.1%
80623	1	< 0.1%
79934	1	< 0.1%
79828	1	< 0.1%
79535	1	< 0.1%
79203	1	< 0.1%
78547	1	< 0.1%
78406	1	< 0.1%
78151	1	< 0.1%

Wind generation (MW)
Real number (ℝ)

Distinct	17422
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5688.662

Minimum	103
Maximum	20912
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	103
5-th percentile	905
Q1	2432
median	4734
Q3	7925
95-th percentile	13973
Maximum	20912
Range	20809
Interquartile range (IQR)	5493

Descriptive statistics

Standard deviation	4067.1345
Coefficient of variation (CV)	0.7149545
Kurtosis	0.22244728
Mean	5688.662
Median Absolute Deviation (MAD)	2588
Skewness	0.93888986
Sum	8.9504271 × 10⁸
Variance	16541583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1533	34	< 0.1%
2816	34	< 0.1%
1206	33	< 0.1%
1962	33	< 0.1%
1377	33	< 0.1%
2167	33	< 0.1%
2320	33	< 0.1%
1382	33	< 0.1%
955	32	< 0.1%
2075	32	< 0.1%
Other values (17412)	157008	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
103	1	< 0.1%
109	1	< 0.1%
115	1	< 0.1%
118	1	< 0.1%
119	1	< 0.1%
121	1	< 0.1%
124	1	< 0.1%
125	1	< 0.1%
127	1	< 0.1%
129	1	< 0.1%

Value	Count	Frequency (%)
20912	1	< 0.1%
20890	1	< 0.1%
20845	1	< 0.1%
20821	1	< 0.1%
20818	1	< 0.1%
20807	1	< 0.1%
20774	1	< 0.1%
20758	1	< 0.1%
20731	1	< 0.1%
20703	1	< 0.1%

Solar generation (MW)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8411
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1157.4499

Minimum	0
Maximum	9892
Zeros	77767
Zeros (%)	49.4%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	1739
95-th percentile	5417.15
Maximum	9892
Range	9892
Interquartile range (IQR)	1739

Descriptive statistics

Standard deviation	1870.2579
Coefficient of variation (CV)	1.6158436
Kurtosis	2.6346176
Mean	1157.4499
Median Absolute Deviation (MAD)	3
Skewness	1.8055438
Sum	1.8211085 × 10⁸
Variance	3497864.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	77767	49.4%
1	460	0.3%
2	302	0.2%
3	284	0.2%
4	225	0.1%
5	207	0.1%
9	199	0.1%
6	183	0.1%
8	163	0.1%
10	158	0.1%
Other values (8401)	77390	49.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	77767	49.4%
1	460	0.3%
2	302	0.2%
3	284	0.2%
4	225	0.1%
5	207	0.1%
6	183	0.1%
7	157	0.1%
8	163	0.1%
9	199	0.1%

Value	Count	Frequency (%)
9892	1	< 0.1%
9888	1	< 0.1%
9821	1	< 0.1%
9797	1	< 0.1%
9731	1	< 0.1%
9728	1	< 0.1%
9708	1	< 0.1%
9697	1	< 0.1%
9694	2	< 0.1%
9691	1	< 0.1%

Hydro generation (MW)
Real number (ℝ)

Distinct	1317
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	418.49401

Minimum	0
Maximum	1403
Zeros	65
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	72
Q1	208
median	386
Q3	594
95-th percentile	888
Maximum	1403
Range	1403
Interquartile range (IQR)	386

Descriptive statistics

Standard deviation	254.49728
Coefficient of variation (CV)	0.60812646
Kurtosis	-0.40072376
Mean	418.49401
Median Absolute Deviation (MAD)	191
Skewness	0.5381341
Sum	65845011
Variance	64768.871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
141	283	0.2%
121	281	0.2%
102	279	0.2%
130	278	0.2%
156	273	0.2%
230	272	0.2%
58	272	0.2%
158	271	0.2%
113	271	0.2%
64	266	0.2%
Other values (1307)	154592	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	65	< 0.1%
11	10	< 0.1%
12	45	< 0.1%
13	55	< 0.1%
14	3	< 0.1%
15	2	< 0.1%
16	21	< 0.1%
17	2	< 0.1%
18	46	< 0.1%
19	57	< 0.1%

Value	Count	Frequency (%)
1403	1	< 0.1%
1397	3	< 0.1%
1386	1	< 0.1%
1382	1	< 0.1%
1379	1	< 0.1%
1377	1	< 0.1%
1376	2	< 0.1%
1375	1	< 0.1%
1374	1	< 0.1%
1371	1	< 0.1%

Biomass generation (MW)
Real number (ℝ)

Distinct	2966
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1110.0334

Minimum	0
Maximum	3262
Zeros	67010
Zeros (%)	42.6%
Negative	0
Negative (%)	0.0%
Memory size	614.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1127
Q3	2083
95-th percentile	2917
Maximum	3262
Range	3262
Interquartile range (IQR)	2083

Descriptive statistics

Standard deviation	1077.2351
Coefficient of variation (CV)	0.97045292
Kurtosis	-1.4591405
Mean	1110.0334
Median Absolute Deviation (MAD)	1127
Skewness	0.25390676
Sum	1.7465043 × 10⁸
Variance	1160435.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	67010	42.6%
2048	127	0.1%
681	127	0.1%
2044	122	0.1%
2046	121	0.1%
2045	114	0.1%
2043	111	0.1%
1764	110	0.1%
2047	108	0.1%
2012	108	0.1%
Other values (2956)	89280	56.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67010	42.6%
74	1	< 0.1%
81	2	< 0.1%
82	3	< 0.1%
83	2	< 0.1%
84	2	< 0.1%
85	1	< 0.1%
87	2	< 0.1%
90	2	< 0.1%
91	1	< 0.1%

Value	Count	Frequency (%)
3262	1	< 0.1%
3204	1	< 0.1%
3177	1	< 0.1%
3169	2	< 0.1%
3168	1	< 0.1%
3166	1	< 0.1%
3161	2	< 0.1%
3160	4	< 0.1%
3159	4	< 0.1%
3158	4	< 0.1%

Auto

Heatmap
Table

	System Buy Price(GBP/MWh)	Market Index Price (£/MWh)	Market Index Volume (MWh)	Settlement Period	National demand (MW)	Embbeded wind generation (MW)	Embbeded solar generation (MW)	Total system demand (MW)	Wind generation (MW)	Solar generation (MW)	Hydro generation (MW)	Biomass generation (MW)
System Buy Price(GBP/MWh)	1.000	0.685	0.200	0.110	0.146	-0.009	0.012	0.184	0.070	-0.010	0.074	0.268
Market Index Price (£/MWh)	0.685	1.000	0.292	0.216	0.257	-0.022	0.064	0.298	0.138	0.045	0.084	0.360
Market Index Volume (MWh)	0.200	0.292	1.000	0.455	0.287	0.315	0.254	0.296	0.338	0.210	0.242	0.371
Settlement Period	0.110	0.216	0.455	1.000	0.476	0.053	0.122	0.450	0.036	0.021	0.204	0.034
National demand (MW)	0.146	0.257	0.287	0.476	1.000	0.022	0.197	0.988	-0.013	0.136	0.513	-0.095
Embbeded wind generation (MW)	-0.009	-0.022	0.315	0.053	0.022	1.000	0.030	0.029	0.796	0.028	0.264	0.181
Embbeded solar generation (MW)	0.012	0.064	0.254	0.122	0.197	0.030	1.000	0.173	-0.068	0.948	-0.003	0.048
Total system demand (MW)	0.184	0.298	0.296	0.450	0.988	0.029	0.173	1.000	0.009	0.115	0.512	-0.082
Wind generation (MW)	0.070	0.138	0.338	0.036	-0.013	0.796	-0.068	0.009	1.000	-0.069	0.243	0.330
Solar generation (MW)	-0.010	0.045	0.210	0.021	0.136	0.028	0.948	0.115	-0.069	1.000	-0.037	0.053
Hydro generation (MW)	0.074	0.084	0.242	0.204	0.513	0.264	-0.003	0.512	0.243	-0.037	1.000	0.030
Biomass generation (MW)	0.268	0.360	0.371	0.034	-0.095	0.181	0.048	-0.082	0.330	0.053	0.030	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	DATETIME	System Buy Price(GBP/MWh)	Market Index Price (£/MWh)	Market Index Volume (MWh)	Settlement Period	National demand (MW)	Embbeded wind generation (MW)	Total system demand (MW)	Wind generation (MW)	Hydro generation (MW)
0	2014-01-01 00:00:00	54.157001	35.320000	301.500000	1	30008.0	1084.0	31920.0	4469.0	768.0
1	2014-01-01 00:30:00	55.499001	37.279999	365.649994	2	30589.0	1079.0	32491.0	4601.0	767.0
2	2014-01-01 01:00:00	56.230999	41.500000	184.000000	3	30306.0	1079.0	32521.0	4686.0	708.0
3	2014-01-01 01:30:00	52.896999	36.740002	185.149994	4	29280.0	931.0	31735.0	4774.0	716.0
4	2014-01-01 02:00:00	32.040001	32.040001	283.500000	5	28174.0	931.0	30661.0	4670.0	702.0
5	2014-01-01 02:30:00	30.510000	30.510000	322.500000	6	27456.0	994.0	29992.0	4683.0	701.0
6	2014-01-01 03:00:00	50.000000	26.620001	454.299988	7	26391.0	994.0	28888.0	4570.0	701.0
7	2014-01-01 03:30:00	27.604000	24.410000	566.950012	8	25367.0	950.0	27786.0	4665.0	701.0
8	2014-01-01 04:00:00	22.389999	22.389999	554.400024	9	24500.0	950.0	26798.0	4800.0	703.0
9	2014-01-01 04:30:00	20.750000	20.750000	666.650024	10	23943.0	963.0	26264.0	4730.0	704.0

	DATETIME	System Buy Price(GBP/MWh)	Market Index Price (£/MWh)	Market Index Volume (MWh)	Settlement Period	National demand (MW)	Embbeded wind generation (MW)	Total system demand (MW)	Wind generation (MW)	Hydro generation (MW)	Biomass generation (MW)
157328	2023-01-01 19:00:00	250.000000	197.279999	1897.650024	39	30330.0	996.0	31475.0	7396.0	1028.0	1432.0
157329	2023-01-01 19:30:00	250.000000	200.029999	1808.599976	40	29100.0	982.0	30275.0	7040.0	856.0	1435.0
157330	2023-01-01 20:00:00	230.000000	196.889999	2324.500000	41	28532.0	948.0	29486.0	7005.0	785.0	1430.0
157331	2023-01-01 20:30:00	217.000000	182.919998	2281.300049	42	28164.0	914.0	29156.0	6912.0	730.0	1420.0
157332	2023-01-01 21:00:00	230.000000	188.570007	2592.600098	43	27163.0	895.0	27978.0	6660.0	547.0	1415.0
157333	2023-01-01 21:30:00	217.000000	177.899994	2474.449951	44	26018.0	875.0	26756.0	6420.0	529.0	1408.0
157334	2023-01-01 22:00:00	42.000000	161.759995	2339.300049	45	25146.0	863.0	25754.0	6095.0	501.0	1415.0
157335	2023-01-01 22:30:00	290.000000	166.000000	2236.500000	46	24139.0	850.0	24790.0	5614.0	520.0	1420.0
157336	2023-01-01 23:00:00	236.000000	156.509995	617.549988	47	22885.0	917.0	23783.0	4856.0	488.0	1352.0
157337	2023-01-01 23:30:00	151.350006	151.350006	969.250000	48	21971.0	983.0	23151.0	4617.0	453.0	1267.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample